📐 ConstructQ · CreateProject — ER Diagram v14.0

15 ตาราง · v14.0 feature · Confirm popup · Editable WBS · v10.0 change template
🔑 Primary Key
🔗 Foreign Key
Core
Site
Members
Files
WBS
Templates
Master
Lookup
Audit (v14.0)
Core
Site Hierarchy
Members / Files / WBS
Templates (Library)
Lookup / Audit
projectsCore
idBIGSERIAL
codeVARCHAR(40)
nameVARCHAR(200)
typeVARCHAR(80)
clientVARCHAR(200)
contract_valueNUMERIC
start_dateDATE
end_dateDATE
statusVARCHAR(20)
organization_id→ orgs
created_by→ users
Stepper 01
project_sitesStep 02 L1
idBIGSERIAL
project_id→ projects
codeVARCHAR(20)
nameVARCHAR(200)
addressTEXT
subdistrictVARCHAR(100)
districtVARCHAR(100)
provinceVARCHAR(100)
project_zonesL2
idBIGSERIAL
site_id→ sites
codeVARCHAR(20)
nameVARCHAR(200)
areaVARCHAR(120)
project_floorsL3
idBIGSERIAL
zone_id→ zones
code · nameVARCHAR
project_roomsL4 leaf
idBIGSERIAL
floor_id→ floors
code · nameVARCHAR
room_typeVARCHAR(40)
project_membersStep 03
idBIGSERIAL
project_id→ projects
user_id→ users
name · emailVARCHAR
phone · roleVARCHAR
project_filesStep 04
idBIGSERIAL
project_id→ projects
name · file_typeVARCHAR
version · urlVARCHAR/TEXT
uploaded_by→ users
project_wbsStep 05 · v12
idBIGSERIAL
project_id→ projects
level · codeCHAR(2)/VARCHAR
parent_code · nameVARCHAR
ref_std→ ref_standards
risk · hw_statusCHAR(1)/VARCHAR
owner_user_id→ users
site_id · zone_id→ sites/zones
statusVARCHAR(20)
v12.0 editable L1/L2/L3
project_wbs_sourcesSnapshot
idBIGSERIAL
project_id→ projects UQ
modeVARCHAR(20)
wbs_template_id→ wbs_templates
template_versionVARCHAR(10)
v10.0 change template
project_templates9 CP_TEMPLATES
idBIGSERIAL
codeVARCHAR(40) UQ
name_th · name_enVARCHAR
desc_th · desc_enTEXT
iconVARCHAR(40)
type_keySMALLINT
project_template_dataJSON
idBIGSERIAL
project_template_id→ tpl UQ
payloadJSONB
project/sites/members/wbs sample
wbs_templates8 master
idBIGSERIAL
code · versionVARCHAR
name_th · name_enVARCHAR
tags · iconVARCHAR
wbs_template_rows~381
idBIGSERIAL
template_id→ wbs_templates
level · codeCHAR/VARCHAR
name · risk · hwVARCHAR
ref_standards22 · v12.0
idBIGSERIAL
codeVARCHAR(50) UQ
label_en · label_thVARCHAR
categoryVARCHAR(40)
sort_orderINT
ACI · AISC · AWS · ASTM · TIS ...
project_auditv14.0
idBIGSERIAL
project_id→ projects
actor_id→ users
actor_nameVARCHAR(200)
actionVARCHAR(40)
change_summaryTEXT
wbs_snapshotJSONB
diffJSONB
ipVARCHAR(45)
Confirm popup logs full summary

🔗 ความสัมพันธ์ระหว่างตาราง

projects─1:N→project_sites(หลายไซต์)
project_sites─1:N→project_zones
project_zones─1:N→project_floors
project_floors─1:N→project_rooms
projects─1:N→project_members
projects─1:N→project_files
projects─1:N→project_wbs
projects─1:1→project_wbs_sources
projects─1:N→project_audit(v14.0)
project_wbs─N:1→ref_standards(v12.0)
wbs_templates─1:N→wbs_template_rows
project_wbs_sources─N:1→wbs_templates
project_templates─1:1→project_template_data

📊 ตัวอย่างข้อมูล · Sample Data

project_templates (9 CP_TEMPLATES · ทุกรายการในไฟล์)

idcodename_thname_entype_keysample projectWBS rows
1officeอาคารสำนักงานOffice Building0CQ-2026-009118
2residentialอาคารพักอาศัยResidential1CQ-2026-010217
3infraโครงสร้างพื้นฐานInfrastructure2CQ-2026-021018
4renovationปรับปรุงRenovation3CQ-2026-030514
5factoryโรงงานFactory4CQ-2026-040817
6datacenterดาต้าเซ็นเตอร์Data Center5CQ-2026-052115
7solarโซล่าเซลล์Solar Cell6CQ-2026-061216
8evสถานีชาร์จรถไฟฟ้าEV Charging7CQ-2026-073412
9hospitalโรงพยาบาลHospital8CQ-2026-084527

project_wbs_sources (snapshot pattern · v10.0 change template)

idprojectmodewbs_templateversionapplied_at
11templateoffice (id=2)1.12026-06-01 09:30
22templatecondo (id=1)1.12026-06-15 14:20
33import——2026-06-22 10:00
44manual——2026-06-25 11:15

project_audit (v14.0 · Confirm popup + WBS actions)

idprojectactoractionchange_summarydate
11Son PrasertsricreatedCreated project CQ-2026-0091 · 18 WBS rows · L1=3 L2=8 L3=72026-06-01 09:35
21KittisakeditedEdited project scope + contract_value2026-06-05 10:15
31Apinyawbs_updatedAdded 3 L3 rows under 1.2 Concrete via editable UI2026-06-10 14:22
42Kittisaktemplate_changedChanged WBS template from residential v1.0 → office v1.12026-06-18 09:00